Select char_length(cast('123456789 1' as varchar(10))) from rdb$database. Получаем: Exception ... string truncation Т.е. пробел мы обрезать можем, а другие символы нет.
Then in the second table I have select ..., null as opt from... I know that I could have an empty string with '' as
Union select null, null, null, null, null, null, null from information_schema.tables. for a small database containing three tables. this instruction is used in sql injection I tried it and it worked but I didn't really know how it works can somebody help me...
> char array[SIZE] = {0}; Nothing wrong with this. It just assumes that the remaining SIZE-1 elements are also zero, so that's it, job done.
Note: A NULL value is different from a zero value or a field that contains spaces.
The null character (also null terminator or null byte), abbreviated NUL or NULL, is a control character with the value zero. It is present in many character sets, including ISO/IEC 646 (or ASCII)...
Description. The PostgreSQL IS NULL condition is used to test for a NULL value in a SELECT, INSERT, UPDATE, or DELETE statement.
How can I select blank columns as zero? Not sure what you are trying to do. Does this come close? coalesce(nullif(val,''),'0'). Note that "zero" has to be char instead of int.
Union select null, null, null, null, null, null -- test all nulls --*/ ). A. DECLARE @ColumnDynamicSQL nvarchar(MAX)